package org.jeecg.modules.sanitation2.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.jeecg.modules.basic.demo.bed.entity.LwgyBaseBed;
import org.jeecg.modules.sanitation2.entity.*;
import com.baomidou.mybatisplus.extension.service.IService;

import java.io.Serializable;
import java.util.Collection;
import java.util.List;
import java.util.Map;

/**
 * @Description: 卫生打分
 * @Author: jeecg-boot
 * @Date:   2021-04-29
 * @Version: V1.0
 */
public interface ILwgyScoreSanitationService extends IService<LwgyScoreSanitation> {

	/**
	 * 添加一对多
	 *
	 */
	public void saveMain(LwgyScoreSanitation lwgyScoreSanitation,List<LwgyTargetType> lwgyTargetTypeList) ;

	/**
	 * 修改一对多
	 *
	 */
	public void updateMain(LwgyScoreSanitation lwgyScoreSanitation,List<LwgyTargetType> lwgyTargetTypeList);

	/**
	 * 删除一对多
	 */
	public void delMain (String id);

	/**
	 * 批量删除一对多
	 */
	public void delBatchMain (Collection<? extends Serializable> idList);

    IPage<LwgyScoreSanitation> statisticalQuery(Page<LwgyScoreSanitation> page, QueryWrapper<StatisticalQuery> queryWrapper);

    List<StatisticalDTO> getStatistical();

    List<String[]> queryHealthScoreInfo(String weeks);


	IPage<LwgyScoreSanitation> queryPageListCustomScore(Page<LwgyScoreSanitation> page, String scaleBatches,String studentCampus,String studentCollege);


	List<ImageZip>findBySql();

	void executeSql(String sql);


	/**批量添加卫生成绩信息*/
	void insertScoreInfo(List<LwgyScoreSanitation> roomList);

	/** 根据批次查询成绩 */
	List<LwgyScoreSanitation> scoreSearch(String scaleBatches);
}
